https://blog.sylver.dev/build-your-own-sqlite-part-1-listing-tables
As developers, we use databases all the time. But how do they work? In this series, we\'ll try to answer that question by building our own SQLite-compatible database from scratch.
Source code examples will be provided in Rust, but you are encouraged to follow along using your language of choice, as we won\'t be relying on many language-specific features or libraries.
As an introduction, we\'ll implement the simplest version of the `tables` command, which lists the names of all the tables in a database. While this looks simple, we\'ll see that it requires us to make our first deep dive into the SQLite file format.